package com.demo2do.fms.admin.dao.supplier;

import com.demo2do.core.persistence.annotation.Dao;
import com.demo2do.core.persistence.annotation.Query;
import com.demo2do.core.persistence.annotation.Variable;

/**
 * 
 * @author Ysy
 *
 */
@Dao("hibernate")
public interface EmployeeDao {
    
    /**
     * 
     * @param vehicleId
     * @param dutyId
     * @return
     */
    @Query("SELECT id FROM Employee WHERE disabled = false AND vehicleId = :vehicleId AND dutyId = :dutyId")
    public Long loadEmployeeId(@Variable("vehicleId")Long vehicleId, @Variable("dutyId")Long dutyId);
}
